class CreateActsAsPersonTable < ActiveRecord::Migration
  def self.up
    create_table :base_persons, :id => false, :force => true do |t|
      t.string :first_name, :limit => 64, :null => false
      t.string :initial, :limit => 8
      t.string :last_name, :limit => 64, :null => false
      t.string :email, :limit  => 128, :null => false
      t.string :auth_id, :limit => 16
    end
    add_index :base_persons, :auth_id
    add_index :base_persons, :email
  end

  def self.down
    drop_table :base_persons
  end
end
